<?php
   //查询所有商品
   
   $conn = mysqli_connect('localhost', 'root', 'root', '2008');
   mysqli_query($conn, "set charset 'utf8'");
   mysqli_query($conn, "set character set 'utf8'");

   $sql = "select * from shop order by id";
   $res = mysqli_query($conn,$sql);
   
   $list = array();
   while ($row = mysqli_fetch_assoc($res)) {
   array_push($list, $row);   
   }
   echo json_encode(array(
      'code' => 200,
      'body' => array(
         'list' => $list
      )
      ));
?>